﻿<%@ Page Language="C#" AutoEventWireup="true" CodeFile="huizong.aspx.cs" Inherits="index" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>安康供电段材料计划提报系统-段已审批材料汇总</title>
    <style type="text/css">

        .style15
        {
            font-size: x-large;
            font-weight: bold;
        }
        .style16
        {
            width: 100%;
        }
            
        .style11
        {
            font-size: small;
            text-align: left;
        }
        #table1
        {
            width: 900px;
        }
        .style18
        {
            height: 45px;
        }
        .style21
        {
            font-size: small;
        }
        .style22
        {
            height: 120px;
        }
        .style23
        {
            color: #FF3300;
            font-size: large;
        }
        .style30
    {
        width: 32px;
        height: 32px;
    }
        .style1
        {
            font-size: small;
        }
        </style>
    <script language="JavaScript" type="text/javascript" src="Js/datejs/WdatePicker.js"
        defer="defer"></script>

    <script language="JavaScript" type="text/javascript" src="Js/Calendar.js"></script>

<SCRIPT>
<!-- 

top.window.moveTo(0,0); 
if  (document.all)  { 
top.window.resizeTo(screen.availWidth,screen.availHeight); 
} 
else  if  (document.layers||document.getElementById)  { 
if  (top.window.outerHeight<screen.availHeight||top.window.outerWidth<screen.availWidth){ 
top.window.outerHeight  =  screen.availHeight; 
top.window.outerWidth  =  screen.availWidth; 
} 
} 

//--> 
</SCRIPT>
</head>
<body background="images/login-bg.jpg">
    <form id="form1" runat="server">
<div class="style7">
    
        <span class="style21">当前位置：</span><asp:HyperLink ID="HyperLink1" runat="server" 
            CssClass="style7" NavigateUrl="~/index.aspx" style="color: #000000; font-size: small;" 
            ToolTip="点击返回主页面">主页面</asp:HyperLink>
        <span class="style21">→ 段已审批材料汇总</span><br class="style7" />
        <br /></div>
    <div style="text-align: center; font-size: small">
                <br /><a name="shuju"></a>
                <span class="style15">安 康 供 电 段 已 审 材 料 汇 总<br />
                <br />
                </span><asp:ScriptManager ID="ScriptManager1" runat="server">
                </asp:ScriptManager>
           
    </div>
        <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
            <ContentTemplate>
    <div style="font-size: small">
        <asp:SqlDataSource ID="SqlDataSource_chejian" runat="server" 
            ConnectionString="<%$ ConnectionStrings:xxnewsConnectionString %>" 
            
            SelectCommand="SELECT [ch_pwname] FROM [siteman] WHERE (([bm_leibie] LIKE '%' + @bm_leibie + '%') AND ([ch_pwname] LIKE '%' + @ch_pwname2 + '%')) ORDER BY [ch_px]">
            <SelectParameters>
                <asp:Parameter DefaultValue="车间" Name="bm_leibie" Type="String" />
                <asp:Parameter DefaultValue="车间" Name="ch_pwname2" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
        <asp:SqlDataSource ID="SqlDataSource_banzu" runat="server" 
            ConnectionString="<%$ ConnectionStrings:xxnewsConnectionString %>" 
            SelectCommand="SELECT [ch_pwname] FROM [siteman] WHERE (([bm_leibie] = @bm_leibie) AND ([ch_pwname] &lt;&gt; @ch_pwname)) ORDER BY [ch_px]">
            <SelectParameters>
                <asp:ControlParameter ControlID="DropDownList_sscj" Name="bm_leibie" 
                    PropertyName="SelectedValue" Type="String" />
                <asp:ControlParameter ControlID="DropDownList_sscj" Name="ch_pwname" 
                    PropertyName="SelectedValue" Type="String" />
            </SelectParameters>
        </asp:SqlDataSource>
    
        <asp:SqlDataSource ID="SqlDataSourceslr" runat="server" ConnectionString="<%$ ConnectionStrings:xxnewsConnectionString %>" SelectCommand="SELECT   xingming FROM      chakaobaojichuku
WHERE   (banzu = '材料科') AND (zhiwu &lt;&gt; '科长') AND (zhiming = '' OR
                zhiming IS NULL) AND (zhiwu &lt;&gt; '会计员') order by xuhao"></asp:SqlDataSource>
    
        <table ID="table7" align="center" border="0" cellpadding="0" cellspacing="0" 
            width="95%">
            <tr>
                <td height="10" width="9">
                    <img align="absMiddle" border="0" height="10" src="images/l_1_1.jpg" 
                        width="9" /></td>
                <td background="images/l_1_8.jpg" width="100%">
                </td>
                <td height="10" width="9">
                    <img align="absMiddle" border="0" height="10" src="images/l_1_7.jpg" 
                        width="9" /></td>
            </tr>
            <tr>
                <td background="images/l_1_2.jpg" class="style22">
                </td>
                <td align="left" bgcolor="#ffffff" valign="top" width="100%" class="style22">
                    <table ID="table8" align="center" border="0" cellpadding="0" cellspacing="0" 
                        width="100%">
                        <tr>
                            <td class="style18">
                                <asp:UpdatePanel ID="UpdatePanel2" runat="server" UpdateMode="Conditional">
                                    <ContentTemplate>
                                        　类别<asp:DropDownList ID="DropDownList_lei" runat="server">
                                            <asp:ListItem>请选择</asp:ListItem>
            <asp:ListItem>接触网</asp:ListItem>
            <asp:ListItem>电力配电</asp:ListItem>
            <asp:ListItem>变电</asp:ListItem>
            <asp:ListItem>工具配件</asp:ListItem>
            <asp:ListItem>劳保用品</asp:ListItem>
            <asp:ListItem>汽轨车辆</asp:ListItem>
            <asp:ListItem>通用物资</asp:ListItem>
                                        </asp:DropDownList>
                                        &nbsp;受理人<asp:DropDownList ID="DropDownList_slr" runat="server" AppendDataBoundItems="True" DataSourceID="SqlDataSourceslr" DataTextField="xingming" DataValueField="xingming">
                                            <asp:ListItem>请选择</asp:ListItem>
                                        </asp:DropDownList>
                                        &nbsp;日期<asp:DropDownList ID="nian" runat="server" AppendDataBoundItems="True">
                                            <asp:ListItem>请选择</asp:ListItem>
                                        </asp:DropDownList>
                                        年<asp:DropDownList ID="yue" runat="server" AppendDataBoundItems="True">
                                            <asp:ListItem>请选择</asp:ListItem>
                                        </asp:DropDownList>
                                        月&nbsp;车间<asp:DropDownList ID="DropDownList_sscj" runat="server" 
                                            AppendDataBoundItems="True" AutoPostBack="True" CssClass="style11" 
                                            DataSourceID="SqlDataSource_chejian" DataTextField="ch_pwname" 
                                            DataValueField="ch_pwname" 
                                            onselectedindexchanged="DropDownList_sscj_SelectedIndexChanged">
                                            <asp:ListItem>请选择</asp:ListItem>
                                        </asp:DropDownList>
                                        班组<asp:DropDownList ID="DropDownList_zrbz" runat="server" 
                                            AppendDataBoundItems="True" CssClass="style11" 
                                            DataSourceID="SqlDataSource_banzu" DataTextField="ch_pwname" 
                                            DataValueField="ch_pwname">
                                            <asp:ListItem>请选择</asp:ListItem>
                                        </asp:DropDownList>
                                        &nbsp;审批发料情况<asp:DropDownList ID="DropDownList_shenpi" 
                                            runat="server" CssClass="style11">
                                            <asp:ListItem>所有段已审批</asp:ListItem>
                                            <asp:ListItem>所有段已受理</asp:ListItem>
                                            <asp:ListItem>所有段已发料</asp:ListItem>
                                            <asp:ListItem>所有已签收</asp:ListItem>
                                            <asp:ListItem>段已审批未受理</asp:ListItem>
                                            <asp:ListItem>材料科已受理</asp:ListItem>
                                            <asp:ListItem>材料科已发料</asp:ListItem>
                                            <asp:ListItem>材料部分签收</asp:ListItem>
                                            <asp:ListItem>材料全部签收</asp:ListItem>
                                        </asp:DropDownList>
                                        <br />
                                        <br />
                                        　审批部门<span class="style1"><asp:DropDownList ID="DropDownListshenpibumen" runat="server">
                                            <asp:ListItem>请选择</asp:ListItem>
                                            <asp:ListItem>供电技术科</asp:ListItem>
                                            <asp:ListItem>电力技术科</asp:ListItem>
                                            <asp:ListItem>设备科</asp:ListItem>
                                        </asp:DropDownList>
                                        </span>&nbsp;&nbsp;&nbsp;&nbsp;时间范围<asp:DropDownList ID="DropDownList_rqfw" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList_rqfw_SelectedIndexChanged">
                                            <asp:ListItem>请选择</asp:ListItem>
                                            <asp:ListItem>提报时间</asp:ListItem>
                                            <asp:ListItem>车间审批时间</asp:ListItem>
                                            <asp:ListItem>段审批时间</asp:ListItem>
                                            <asp:ListItem>受理时间</asp:ListItem>
                                            <asp:ListItem>发料时间</asp:ListItem>
                                            <asp:ListItem>签收时间</asp:ListItem>
                                        </asp:DropDownList>
                                        <asp:TextBox ID="TextBox_qs" runat="server" onclick="showcalendar(this)" Width="80px"></asp:TextBox>
                                        至<asp:TextBox ID="TextBox_js" runat="server" onclick="showcalendar(this)" Width="80px"></asp:TextBox>
                                        &nbsp;<br /> <br />
                                    </ContentTemplate>
                                </asp:UpdatePanel>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                &nbsp;
                                <asp:Label ID="Label_tiaojian" runat="server" style="color: #FF3300" 
                                    Text="Label"></asp:Label>
                            </td>
                        </tr>
                        <tr>
                            <td>
                                &nbsp;</td>
                        </tr>
                        <tr>
                            <td>
                                <table ID="table9" border="0" cellpadding="0" cellspacing="0" width="100%">
                                    <tr>
                                        <td background="images/line.jpg" height="1">
                                        </td>
                                    </tr>
                                    <tr>
                                        <td>
                                            <table ID="table10" border="0" cellpadding="0" cellspacing="0" width="100%">
                                                <tr>
                                                    <td align="middle" height="35" width="24%">
                                                        <img align="absMiddle" border="0" height="25" src="images/l_1_10.jpg" 
                                                            width="19" /></td>
                                                    <td align="left" style="text-align: center" width="54%">
                                                        <asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/images/sub_3.jpg" 
                                                            onclick="ImageButton1_Click" />
                                                        &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
                                                        <asp:ImageButton ID="ImageButton2" runat="server" 
                                                            ImageUrl="~/images/sub_2.jpg" onclick="ImageButton2_Click" />
                                                    </td>
                                                    <td align="middle" valign="center" width="22%">
                                                        <img align="absMiddle" border="0" height="15" src="images/l_1_12.jpg" 
                                                            width="49" /></td>
                                                </tr>
                                            </table>
                                        </td>
                                    </tr>
                                </table>
                            </td>
                        </tr>
                    </table>
                </td>
                <td background="images/l_1_6.jpg" class="style22">
                </td>
            </tr>
            <tr>
                <td height="10" width="9">
                    <img align="absMiddle" border="0" height="10" src="images/l_1_3.jpg" 
                        width="9" /></td>
                <td background="images/l_1_4.jpg">
                </td>
                <td height="10" width="9">
                    <img align="absMiddle" border="0" height="10" src="images/l_1_5.jpg" 
                        width="9" /></td>
            </tr>
        </table>
    
        <br />
    
     </div>



     <div style="text-align: center">            
           <asp:UpdateProgress ID="UpdateProgress1" runat="server" DisplayAfter="1200" 
               AssociatedUpdatePanelID="UpdatePanel1">
                <ProgressTemplate>
                    <table class="style16">
                        <tr>
                            <td align="right" width="45%">
                                <strong><span class="style23">
                                <img class="style30" 
                src="images/loading.gif" />
                                </span></strong>
                            </td>
                            <td align="left">
                                <strong><span class="style23">正在汇总，请稍侯...</span></strong>
                            </td>
                        </tr>
                    </table>
                </ProgressTemplate>
            </asp:UpdateProgress>
            </div>


        <div style="font-size: small; text-align: center;">     
            <br />
            
            <asp:Label ID="Label_biaoti" runat="server" 
                style="font-weight: 700; font-size: medium"></asp:Label>
            <table class="style16">
                <tr>
                    <td style="text-align: center">
                        <b>
                        <asp:GridView ID="GridView1" runat="server"
                            AutoGenerateColumns="False" CellPadding="4" DataKeyNames="leibie1,leibie2,mingcheng,guige" 
                            EnableModelValidation="True" ForeColor="#333333" 
                            style="text-align: center; font-size: small" 
                            onrowdatabound="GridView1_RowDataBound" Font-Bold="False" 
                            DataSourceID="SqlDataSource1" ShowFooter="True" Width="1000px" EmptyDataText="没有符合条件的汇总数据">
                            <AlternatingRowStyle BackColor="White" />
                            <Columns>
                                <asp:TemplateField HeaderText="序号">
                                    <ItemStyle Width="20px" />
                                </asp:TemplateField>
                                <asp:BoundField DataField="bianhao" HeaderText="物资编码" 
                                    SortExpression="bianhao" >
                                <ItemStyle Width="90px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="leibie1" HeaderText="类别" SortExpression="leibie1" >
                                <ItemStyle Width="80px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="leibie2" HeaderText="子类别" SortExpression="leibie2" Visible="False" >
                                <ItemStyle Width="100px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="mingcheng" HeaderText="材料物资名称" 
                                    SortExpression="mingcheng" />
                                <asp:BoundField DataField="guige" HeaderText="规格型号" SortExpression="guige" 
                                    HtmlEncode="False" >
                                </asp:BoundField>
                                <asp:BoundField DataField="danwei" HeaderText="单位" SortExpression="danwei" >
                                <ItemStyle Width="20px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="zongshu" HeaderText="段审批数量汇总" SortExpression="zongshu" >
                                <ItemStyle Width="20px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="fashu" HeaderText="发料数量汇总" SortExpression="fashu" >
                                <ItemStyle Width="20px" />
                                </asp:BoundField>
                                <asp:BoundField DataField="qianshu" HeaderText="签收数量汇总" SortExpression="qianshu" >
                                <ItemStyle Width="20px" />
                                </asp:BoundField>
                                <asp:TemplateField HeaderText="班组名称 | 单价 | 段审批数量 | 发料数量 | 签收数量 | 备注">
                                    <ItemTemplate>
                                        <asp:GridView ID="GridView_bzmx" runat="server" AutoGenerateColumns="False" 
                                            DataSourceID="SqlDataSource_bzmx" EnableModelValidation="True" 
                                            CellPadding="4" ForeColor="#333333" GridLines="Vertical" ShowHeader="False">
                                            <AlternatingRowStyle BackColor="White" />
                                            <Columns>
                                                <asp:BoundField DataField="banzu" HeaderText="banzu" SortExpression="banzu" >
                                                <ItemStyle Width="100px" />
                                                </asp:BoundField>
                                                <asp:BoundField DataField="danjia" HeaderText="danjia" 
                                                    SortExpression="danjia" >
                                                <ItemStyle Width="20px" />
                                                </asp:BoundField>
                                                <asp:BoundField DataField="zongshu" HeaderText="zongshu" 
                                                    SortExpression="zongshu" >
                                                <ItemStyle Width="20px" />
                                                </asp:BoundField>
                                                <asp:BoundField DataField="fashu" HeaderText="fashu" 
                                                    SortExpression="fashu" >
                                                <ItemStyle Width="20px" />
                                                </asp:BoundField>
                                                <asp:BoundField DataField="qianshu" HeaderText="qianshu" 
                                                    SortExpression="qianshu" >
                                                <ItemStyle Width="20px" />
                                                </asp:BoundField>
                                                <asp:BoundField DataField="beizhu" HeaderText="beizhu" 
                                                    SortExpression="beizhu" >
                                                <ItemStyle Width="200px" />
                                                </asp:BoundField>
                                <asp:HyperLinkField DataNavigateUrlFields="c_id" 
                                    DataNavigateUrlFormatString="showjihua.aspx?id={0}" HeaderText="详细" 
                                    Text="详细" Target="_blank" />

                                            </Columns>
                                            <EditRowStyle BackColor="#2461BF" />
                                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                                            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                                            <RowStyle BackColor="#EFF3FB" />
                                            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                                        </asp:GridView>
                                        <asp:SqlDataSource ID="SqlDataSource_bzmx" runat="server" 
                                            ConnectionString="<%$ ConnectionStrings:xxnewsConnectionString %>" >
                                        </asp:SqlDataSource>
                                    </ItemTemplate>
                                    <ItemStyle Width="450px" />
                                </asp:TemplateField>
                            </Columns>
                            <EditRowStyle BackColor="#2461BF" />
                            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                            <HeaderStyle BackColor="#507CD1" ForeColor="White" />
                            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                            <RowStyle BackColor="#EFF3FB" />
                            <SelectedRowStyle BackColor="#D1DDF1" ForeColor="#333333" />
                        </asp:GridView>
                        </b>
                        <asp:SqlDataSource ID="SqlDataSource1" runat="server"></asp:SqlDataSource>
                        <br />
                        <br />
                        <asp:Label ID="Label_tishi" runat="server" 
                            style="color: #FF6600; font-weight: 700" 
                            Text="注意：红色粗体显示的材料汇总数量与后方班组合计数量不一致，一般为班组重复提报相同物资名称材料计划所致，请查询原始计划单" Visible="False"></asp:Label>
                        <br />
                        <br />
                        <asp:Label ID="label_zongjia" runat="server" 
                            style="color: #FF0000; font-weight: 700" Visible="False"></asp:Label>
                    </td>
                </tr>
            </table>
</div>
            </ContentTemplate>
        </asp:UpdatePanel>                
   </form>
    <p class="style21" style="TEXT-ALIGN: center">
        &nbsp;<br />
        &nbsp;安康供电段信息中心制作 2015</p>
    <p style="text-align: center">
        &nbsp;</p>
    </body>
</html>
